2016-11-17 - 28402 - Break Fix - Adding license to epm explorer spaces #BIExplorer

BREAK FIX

28402 - Adding license to epm explorer spaces

Problem Summary

Need to fix EPM explorer spaces are failing & adding license to EPM explorer spaces.

Admin Info

Purpose
 Need to fix EPM explorer spaces are failing & adding license to EPM explorer spaces.
Requested by
 Michelle Young
Issue Date
 11-18-2016
Resolved by
 Dhananjay G
Resolved Date
 11-25-2016
Document Status
 Complete

Detailed Problem Description

Email from Saravanan on 11/18/2016:

There are few universes which are failing in prod from getting indexed after 7th Nov.
Error message :
Server, NECCGBOBJ1A.ExplorerIndexingServer2, generated the following messages:
Index Creation Failed (
The execution of the specified analysis query failed.-The following database error occurred: The supplied XML is not valid. [ZBPCLIC].[LEVEL01]. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) The following database error occurred: The supplied XML is not valid. [ZBPCLIC].[LEVEL01]. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901))
we have removed the license consolidation in BPC and this universe is still referring to that and hence the failure to index. It was working fine before 11/7. Any thoughts?
EPM.png

Adding license to epm explorer spaces for users want to see the license information.

Email from Saravanan on 12/14/2016:
Please add 3100, 3300, 4000, 4100 to EPM SALES ANALYSIS - APAC universe.

Solution Analysis and Recommendations

1. Need to fix EPM information spaces failed in BI Prod for all regions.
2. Need to analyze the issue in EPM BEx queries.
3. Need to update the License filed in EPM universe.
4. Need to refresh the information spaces for all regions.
5. Need to add sales orgs 3100, 3300, 4000, 4100 to EPM SALES ANALYSIS - APAC universe.

Resolution

1. In BEx Query for EPM universe, only License consolidation(ZBPCLIC) is used earlier, there isn’t any License field that is being used. As license consolidation is removed as a part of requirement from BPC source, the universe & information spaces needs to be refreshed.
2. After removing license consolidation field from information spaces for Global , APAC & Japan regions, the information spaces got indexed successfully.
3. Updated the License field in EPM universe and indexed all the regional information spaces successfully.
4. Added sales Orgs 3100, 3300, 4000, 4100 to EPM SALES ANALYSIS - APAC universe.

Release Information

2016-11-18 - 28402 - Rel Notes - Adding license to epm explorer spaces